﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="liv3DataSetReportViewerCommandePDF" targetNamespace="http://tempuri.org/liv3DataSetReportViewerCommandePDF.xsd" xmlns:mstns="http://tempuri.org/liv3DataSetReportViewerCommandePDF.xsd" xmlns="http://tempuri.org/liv3DataSetReportViewerCommandePDF.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="liv3ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="liv3ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.AppCommerciaux.Properties.Settings.GlobalReference.Default.liv3ConnectionString" Provider="System.Data.SQLite.EF6" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="agendaTableAdapter" GeneratorDataComponentClassName="agendaTableAdapter" Name="agenda" UserDataComponentName="agendaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.agenda" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[agenda] WHERE (([id] = @Original_id) AND ([date_debut] = @Original_date_debut) AND ([date_fin] = @Original_date_fin) AND ((@IsNull_infos_supp = 1 AND [infos_supp] IS NULL) OR ([infos_supp] = @Original_infos_supp)) AND ([id_tiers_contact] = @Original_id_tiers_contact))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_date_debut" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_debut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_date_fin" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_fin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_infos_supp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_infos_supp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[agenda] ([date_debut], [date_fin], [infos_supp], [id_tiers_contact]) VALUES (@date_debut, @date_fin, @infos_supp, @id_tiers_contact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@date_debut" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_debut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@date_fin" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_fin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@infos_supp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [date_debut], [date_fin], [infos_supp], [id_tiers_contact] FROM [agenda]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[agenda] SET [date_debut] = @date_debut, [date_fin] = @date_fin, [infos_supp] = @infos_supp, [id_tiers_contact] = @id_tiers_contact WHERE (([id] = @Original_id) AND ([date_debut] = @Original_date_debut) AND ([date_fin] = @Original_date_fin) AND ((@IsNull_infos_supp = 1 AND [infos_supp] IS NULL) OR ([infos_supp] = @Original_infos_supp)) AND ([id_tiers_contact] = @Original_id_tiers_contact))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@date_debut" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_debut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@date_fin" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_fin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@infos_supp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_date_debut" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_debut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_date_fin" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="date_fin" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_infos_supp" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_infos_supp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="infos_supp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="date_debut" DataSetColumn="date_debut" />
              <Mapping SourceColumn="date_fin" DataSetColumn="date_fin" />
              <Mapping SourceColumn="infos_supp" DataSetColumn="infos_supp" />
              <Mapping SourceColumn="id_tiers_contact" DataSetColumn="id_tiers_contact" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="commandeclientTableAdapter" GeneratorDataComponentClassName="commandeclientTableAdapter" Name="commandeclient" UserDataComponentName="commandeclientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.commandeclient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[commandeclient] WHERE (([id] = @Original_id) AND ([dateCreation] = @Original_dateCreation) AND ([statut] = @Original_statut) AND ((@IsNull_totalHT = 1 AND [totalHT] IS NULL) OR ([totalHT] = @Original_totalHT)) AND ((@IsNull_totalTTC = 1 AND [totalTTC] IS NULL) OR ([totalTTC] = @Original_totalTTC)) AND ((@IsNull_montantAcompte = 1 AND [montantAcompte] IS NULL) OR ([montantAcompte] = @Original_montantAcompte)) AND ((@IsNull_montantTva = 1 AND [montantTva] IS NULL) OR ([montantTva] = @Original_montantTva)) AND ((@IsNull_montantRemise = 1 AND [montantRemise] IS NULL) OR ([montantRemise] = @Original_montantRemise)) AND ([id_tiers_societe] = @Original_id_tiers_societe) AND ([id_tiers_contact] = @Original_id_tiers_contact) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dateCreation" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateCreation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_statut" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="statut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_totalHT" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_totalTTC" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantAcompte" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantAcompte" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantTva" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantRemise" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantRemise" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[commandeclient] ([id], [dateCreation], [statut], [totalHT], [totalTTC], [montantAcompte], [montantTva], [montantRemise], [id_tiers_societe], [id_tiers_contact], [synchro]) VALUES (@id, @dateCreation, @statut, @totalHT, @totalTTC, @montantAcompte, @montantTva, @montantRemise, @id_tiers_societe, @id_tiers_contact, @synchro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dateCreation" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateCreation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@statut" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="statut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantAcompte" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantRemise" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [dateCreation], [statut], [totalHT], [totalTTC], [montantAcompte], [montantTva], [montantRemise], [id_tiers_societe], [id_tiers_contact], [synchro] FROM [commandeclient]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[commandeclient] SET [id] = @id, [dateCreation] = @dateCreation, [statut] = @statut, [totalHT] = @totalHT, [totalTTC] = @totalTTC, [montantAcompte] = @montantAcompte, [montantTva] = @montantTva, [montantRemise] = @montantRemise, [id_tiers_societe] = @id_tiers_societe, [id_tiers_contact] = @id_tiers_contact, [synchro] = @synchro WHERE (([id] = @Original_id) AND ([dateCreation] = @Original_dateCreation) AND ([statut] = @Original_statut) AND ((@IsNull_totalHT = 1 AND [totalHT] IS NULL) OR ([totalHT] = @Original_totalHT)) AND ((@IsNull_totalTTC = 1 AND [totalTTC] IS NULL) OR ([totalTTC] = @Original_totalTTC)) AND ((@IsNull_montantAcompte = 1 AND [montantAcompte] IS NULL) OR ([montantAcompte] = @Original_montantAcompte)) AND ((@IsNull_montantTva = 1 AND [montantTva] IS NULL) OR ([montantTva] = @Original_montantTva)) AND ((@IsNull_montantRemise = 1 AND [montantRemise] IS NULL) OR ([montantRemise] = @Original_montantRemise)) AND ([id_tiers_societe] = @Original_id_tiers_societe) AND ([id_tiers_contact] = @Original_id_tiers_contact) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dateCreation" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateCreation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@statut" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="statut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantAcompte" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@montantRemise" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dateCreation" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateCreation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_statut" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="statut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_totalHT" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_totalTTC" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantAcompte" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantAcompte" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantAcompte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantTva" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantTva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_montantRemise" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_montantRemise" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="montantRemise" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_contact" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_contact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="dateCreation" DataSetColumn="dateCreation" />
              <Mapping SourceColumn="statut" DataSetColumn="statut" />
              <Mapping SourceColumn="totalHT" DataSetColumn="totalHT" />
              <Mapping SourceColumn="totalTTC" DataSetColumn="totalTTC" />
              <Mapping SourceColumn="montantAcompte" DataSetColumn="montantAcompte" />
              <Mapping SourceColumn="montantTva" DataSetColumn="montantTva" />
              <Mapping SourceColumn="montantRemise" DataSetColumn="montantRemise" />
              <Mapping SourceColumn="id_tiers_societe" DataSetColumn="id_tiers_societe" />
              <Mapping SourceColumn="id_tiers_contact" DataSetColumn="id_tiers_contact" />
              <Mapping SourceColumn="synchro" DataSetColumn="synchro" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.commandeclient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [dateCreation], [statut], [totalHT], [totalTTC], [montantAcompte], [montantTva], [montantRemise], [id_tiers_societe], [id_tiers_contact], [synchro] FROM [commandeclient] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.commandeclient" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="france_villesTableAdapter" GeneratorDataComponentClassName="france_villesTableAdapter" Name="france_villes" UserDataComponentName="france_villesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.france_villes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[france_villes] WHERE (([ville_id] = @Original_ville_id) AND ((@IsNull_ville_departement = 1 AND [ville_departement] IS NULL) OR ([ville_departement] = @Original_ville_departement)) AND ((@IsNull_ville_slug = 1 AND [ville_slug] IS NULL) OR ([ville_slug] = @Original_ville_slug)) AND ((@IsNull_ville_nom = 1 AND [ville_nom] IS NULL) OR ([ville_nom] = @Original_ville_nom)) AND ((@IsNull_ville_nom_simple = 1 AND [ville_nom_simple] IS NULL) OR ([ville_nom_simple] = @Original_ville_nom_simple)) AND ((@IsNull_ville_nom_reel = 1 AND [ville_nom_reel] IS NULL) OR ([ville_nom_reel] = @Original_ville_nom_reel)) AND ((@IsNull_ville_code_postal = 1 AND [ville_code_postal] IS NULL) OR ([ville_code_postal] = @Original_ville_code_postal)) AND ((@IsNull_ville_population_2012 = 1 AND [ville_population_2012] IS NULL) OR ([ville_population_2012] = @Original_ville_population_2012)) AND ((@IsNull_ville_longitude_deg = 1 AND [ville_longitude_deg] IS NULL) OR ([ville_longitude_deg] = @Original_ville_longitude_deg)) AND ((@IsNull_ville_latitude_deg = 1 AND [ville_latitude_deg] IS NULL) OR ([ville_latitude_deg] = @Original_ville_latitude_deg)) AND ((@IsNull_ville_nom_departement = 1 AND [ville_nom_departement] IS NULL) OR ([ville_nom_departement] = @Original_ville_nom_departement)) AND ((@IsNull_ville_nom_region = 1 AND [ville_nom_region] IS NULL) OR ([ville_nom_region] = @Original_ville_nom_region)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ville_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_departement" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_slug" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_slug" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_simple" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_simple" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_reel" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_reel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_code_postal" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_code_postal" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_population_2012" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ville_population_2012" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_longitude_deg" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ville_longitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_latitude_deg" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ville_latitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_departement" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_region" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_region" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[france_villes] ([ville_departement], [ville_slug], [ville_nom], [ville_nom_simple], [ville_nom_reel], [ville_code_postal], [ville_population_2012], [ville_longitude_deg], [ville_latitude_deg], [ville_nom_departement], [ville_nom_region]) VALUES (@ville_departement, @ville_slug, @ville_nom, @ville_nom_simple, @ville_nom_reel, @ville_code_postal, @ville_population_2012, @ville_longitude_deg, @ville_latitude_deg, @ville_nom_departement, @ville_nom_region)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_slug" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_simple" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_reel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_code_postal" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ville_population_2012" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ville_longitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ville_latitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_region" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [ville_id], [ville_departement], [ville_slug], [ville_nom], [ville_nom_simple], [ville_nom_reel], [ville_code_postal], [ville_population_2012], [ville_longitude_deg], [ville_latitude_deg], [ville_nom_departement], [ville_nom_region] FROM [france_villes]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[france_villes] SET [ville_departement] = @ville_departement, [ville_slug] = @ville_slug, [ville_nom] = @ville_nom, [ville_nom_simple] = @ville_nom_simple, [ville_nom_reel] = @ville_nom_reel, [ville_code_postal] = @ville_code_postal, [ville_population_2012] = @ville_population_2012, [ville_longitude_deg] = @ville_longitude_deg, [ville_latitude_deg] = @ville_latitude_deg, [ville_nom_departement] = @ville_nom_departement, [ville_nom_region] = @ville_nom_region WHERE (([ville_id] = @Original_ville_id) AND ((@IsNull_ville_departement = 1 AND [ville_departement] IS NULL) OR ([ville_departement] = @Original_ville_departement)) AND ((@IsNull_ville_slug = 1 AND [ville_slug] IS NULL) OR ([ville_slug] = @Original_ville_slug)) AND ((@IsNull_ville_nom = 1 AND [ville_nom] IS NULL) OR ([ville_nom] = @Original_ville_nom)) AND ((@IsNull_ville_nom_simple = 1 AND [ville_nom_simple] IS NULL) OR ([ville_nom_simple] = @Original_ville_nom_simple)) AND ((@IsNull_ville_nom_reel = 1 AND [ville_nom_reel] IS NULL) OR ([ville_nom_reel] = @Original_ville_nom_reel)) AND ((@IsNull_ville_code_postal = 1 AND [ville_code_postal] IS NULL) OR ([ville_code_postal] = @Original_ville_code_postal)) AND ((@IsNull_ville_population_2012 = 1 AND [ville_population_2012] IS NULL) OR ([ville_population_2012] = @Original_ville_population_2012)) AND ((@IsNull_ville_longitude_deg = 1 AND [ville_longitude_deg] IS NULL) OR ([ville_longitude_deg] = @Original_ville_longitude_deg)) AND ((@IsNull_ville_latitude_deg = 1 AND [ville_latitude_deg] IS NULL) OR ([ville_latitude_deg] = @Original_ville_latitude_deg)) AND ((@IsNull_ville_nom_departement = 1 AND [ville_nom_departement] IS NULL) OR ([ville_nom_departement] = @Original_ville_nom_departement)) AND ((@IsNull_ville_nom_region = 1 AND [ville_nom_region] IS NULL) OR ([ville_nom_region] = @Original_ville_nom_region)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_slug" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_simple" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_reel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_code_postal" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ville_population_2012" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ville_longitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ville_latitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville_nom_region" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ville_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_departement" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_departement" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_slug" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_slug" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_slug" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_simple" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_simple" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_simple" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_reel" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_reel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_reel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_code_postal" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_code_postal" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_code_postal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_population_2012" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ville_population_2012" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="ville_population_2012" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_longitude_deg" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ville_longitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_longitude_deg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_latitude_deg" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ville_latitude_deg" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="ville_latitude_deg" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_departement" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_departement" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_departement" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ville_nom_region" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville_nom_region" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville_nom_region" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ville_id" DataSetColumn="ville_id" />
              <Mapping SourceColumn="ville_departement" DataSetColumn="ville_departement" />
              <Mapping SourceColumn="ville_slug" DataSetColumn="ville_slug" />
              <Mapping SourceColumn="ville_nom" DataSetColumn="ville_nom" />
              <Mapping SourceColumn="ville_nom_simple" DataSetColumn="ville_nom_simple" />
              <Mapping SourceColumn="ville_nom_reel" DataSetColumn="ville_nom_reel" />
              <Mapping SourceColumn="ville_code_postal" DataSetColumn="ville_code_postal" />
              <Mapping SourceColumn="ville_population_2012" DataSetColumn="ville_population_2012" />
              <Mapping SourceColumn="ville_longitude_deg" DataSetColumn="ville_longitude_deg" />
              <Mapping SourceColumn="ville_latitude_deg" DataSetColumn="ville_latitude_deg" />
              <Mapping SourceColumn="ville_nom_departement" DataSetColumn="ville_nom_departement" />
              <Mapping SourceColumn="ville_nom_region" DataSetColumn="ville_nom_region" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="lignecommandeclientTableAdapter" GeneratorDataComponentClassName="lignecommandeclientTableAdapter" Name="lignecommandeclient" UserDataComponentName="lignecommandeclientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.lignecommandeclient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[lignecommandeclient] WHERE (([id] = @Original_id) AND ([quantite] = @Original_quantite) AND ([puHT] = @Original_puHT) AND ([tauxTva] = @Original_tauxTva) AND ([totalHT] = @Original_totalHT) AND ([totalTTC] = @Original_totalTTC) AND ([id_commandeclient] = @Original_id_commandeclient) AND ([id_produit] = @Original_id_produit) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_quantite" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="quantite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_puHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="puHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tauxTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tauxTva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_commandeclient" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_commandeclient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_produit" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_produit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[lignecommandeclient] ([id], [quantite], [puHT], [tauxTva], [totalHT], [totalTTC], [id_commandeclient], [id_produit], [synchro]) VALUES (@id, @quantite, @puHT, @tauxTva, @totalHT, @totalTTC, @id_commandeclient, @id_produit, @synchro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@quantite" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="quantite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@puHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="puHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tauxTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tauxTva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_commandeclient" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_commandeclient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_produit" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_produit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [quantite], [puHT], [tauxTva], [totalHT], [totalTTC], [id_commandeclient], [id_produit], [synchro] FROM [lignecommandeclient]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[lignecommandeclient] SET [id] = @id, [quantite] = @quantite, [puHT] = @puHT, [tauxTva] = @tauxTva, [totalHT] = @totalHT, [totalTTC] = @totalTTC, [id_commandeclient] = @id_commandeclient, [id_produit] = @id_produit, [synchro] = @synchro WHERE (([id] = @Original_id) AND ([quantite] = @Original_quantite) AND ([puHT] = @Original_puHT) AND ([tauxTva] = @Original_tauxTva) AND ([totalHT] = @Original_totalHT) AND ([totalTTC] = @Original_totalTTC) AND ([id_commandeclient] = @Original_id_commandeclient) AND ([id_produit] = @Original_id_produit) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@quantite" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="quantite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@puHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="puHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@tauxTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tauxTva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_commandeclient" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_commandeclient" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_produit" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_produit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_quantite" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="quantite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_puHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="puHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_tauxTva" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="tauxTva" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalHT" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalHT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_totalTTC" Precision="0" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="totalTTC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_commandeclient" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_commandeclient" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_produit" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_produit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="quantite" DataSetColumn="quantite" />
              <Mapping SourceColumn="puHT" DataSetColumn="puHT" />
              <Mapping SourceColumn="tauxTva" DataSetColumn="tauxTva" />
              <Mapping SourceColumn="totalHT" DataSetColumn="totalHT" />
              <Mapping SourceColumn="totalTTC" DataSetColumn="totalTTC" />
              <Mapping SourceColumn="id_commandeclient" DataSetColumn="id_commandeclient" />
              <Mapping SourceColumn="id_produit" DataSetColumn="id_produit" />
              <Mapping SourceColumn="synchro" DataSetColumn="synchro" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.lignecommandeclient" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById_CommandeClient" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById_CommandeClient" GeneratorSourceName="FillById_CommandeClient" GetMethodModifier="Public" GetMethodName="GetDataById_CommandeClient" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById_CommandeClient" UserSourceName="FillById_CommandeClient">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        id, quantite, puHT, tauxTva, totalHT, totalTTC, id_commandeclient, id_produit, synchro
FROM            lignecommandeclient
WHERE        (id_commandeclient = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id_commandeclient" DataSourceName="main.lignecommandeclient" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id_commandeclient" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="produitTableAdapter" GeneratorDataComponentClassName="produitTableAdapter" Name="produit" UserDataComponentName="produitTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.produit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[produit] WHERE (([id] = @Original_id) AND ([libelle] = @Original_libelle) AND ([pu] = @Original_pu) AND ([id_unite] = @Original_id_unite) AND ([id_tva] = @Original_id_tva))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_libelle" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pu" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_unite" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_unite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tva" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tva" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[produit] ([id], [libelle], [pu], [id_unite], [id_tva]) VALUES (@id, @libelle, @pu, @id_unite, @id_tva)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@libelle" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pu" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_unite" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_unite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tva" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tva" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [libelle], [pu], [id_unite], [id_tva] FROM [produit]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[produit] SET [id] = @id, [libelle] = @libelle, [pu] = @pu, [id_unite] = @id_unite, [id_tva] = @id_tva WHERE (([id] = @Original_id) AND ([libelle] = @Original_libelle) AND ([pu] = @Original_pu) AND ([id_unite] = @Original_id_unite) AND ([id_tva] = @Original_id_tva))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@libelle" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@pu" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_unite" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_unite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tva" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tva" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_libelle" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="libelle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_pu" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="pu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_unite" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_unite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tva" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tva" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="libelle" DataSetColumn="libelle" />
              <Mapping SourceColumn="pu" DataSetColumn="pu" />
              <Mapping SourceColumn="id_unite" DataSetColumn="id_unite" />
              <Mapping SourceColumn="id_tva" DataSetColumn="id_tva" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.produit" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillById_Produit" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataById_Produit" GeneratorSourceName="FillById_Produit" GetMethodModifier="Public" GetMethodName="GetDataById_Produit" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataById_Produit" UserSourceName="FillById_Produit">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [libelle], [pu], [id_unite], [id_tva] FROM [produit] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.produit" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stockTableAdapter" GeneratorDataComponentClassName="stockTableAdapter" Name="stock" UserDataComponentName="stockTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[stock] WHERE (([StockDateEntrer] = @Original_StockDateEntrer) AND ([StockQuantite] = @Original_StockQuantite) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_StockDateEntrer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="StockDateEntrer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_StockQuantite" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="StockQuantite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[stock] ([StockDateEntrer], [StockQuantite], [id]) VALUES (@StockDateEntrer, @StockQuantite, @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@StockDateEntrer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="StockDateEntrer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@StockQuantite" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="StockQuantite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [StockDateEntrer], [StockQuantite], [id] FROM [stock]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[stock] SET [StockDateEntrer] = @StockDateEntrer, [StockQuantite] = @StockQuantite, [id] = @id WHERE (([StockDateEntrer] = @Original_StockDateEntrer) AND ([StockQuantite] = @Original_StockQuantite) AND ([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@StockDateEntrer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="StockDateEntrer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@StockQuantite" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="StockQuantite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_StockDateEntrer" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="StockDateEntrer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_StockQuantite" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="StockQuantite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StockDateEntrer" DataSetColumn="StockDateEntrer" />
              <Mapping SourceColumn="StockQuantite" DataSetColumn="StockQuantite" />
              <Mapping SourceColumn="id" DataSetColumn="id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.stock" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [StockDateEntrer], [StockQuantite], [id] FROM [stock]  WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.stock" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tiers_contactTableAdapter" GeneratorDataComponentClassName="tiers_contactTableAdapter" Name="tiers_contact" UserDataComponentName="tiers_contactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tiers_contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[tiers_contact] WHERE (([id] = @Original_id) AND ([nom] = @Original_nom) AND ([prenom] = @Original_prenom) AND ([fonction] = @Original_fonction) AND ([mail] = @Original_mail) AND ([telFixe] = @Original_telFixe) AND ((@IsNull_telPortable = 1 AND [telPortable] IS NULL) OR ([telPortable] = @Original_telPortable)) AND ((@IsNull_dateNaissance = 1 AND [dateNaissance] IS NULL) OR ([dateNaissance] = @Original_dateNaissance)) AND ([id_tiers_societe] = @Original_id_tiers_societe))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="prenom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fonction" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fonction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mail" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telFixe" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telFixe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telPortable" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telPortable" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateNaissance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dateNaissance" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[tiers_contact] ([id], [nom], [prenom], [fonction], [mail], [telFixe], [telPortable], [dateNaissance], [id_tiers_societe]) VALUES (@id, @nom, @prenom, @fonction, @mail, @telFixe, @telPortable, @dateNaissance, @id_tiers_societe)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="prenom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fonction" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fonction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mail" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telFixe" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telFixe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telPortable" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dateNaissance" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [nom], [prenom], [fonction], [mail], [telFixe], [telPortable], [dateNaissance], [id_tiers_societe] FROM [tiers_contact]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[tiers_contact] SET [id] = @id, [nom] = @nom, [prenom] = @prenom, [fonction] = @fonction, [mail] = @mail, [telFixe] = @telFixe, [telPortable] = @telPortable, [dateNaissance] = @dateNaissance, [id_tiers_societe] = @id_tiers_societe WHERE (([id] = @Original_id) AND ([nom] = @Original_nom) AND ([prenom] = @Original_prenom) AND ([fonction] = @Original_fonction) AND ([mail] = @Original_mail) AND ([telFixe] = @Original_telFixe) AND ((@IsNull_telPortable = 1 AND [telPortable] IS NULL) OR ([telPortable] = @Original_telPortable)) AND ((@IsNull_dateNaissance = 1 AND [dateNaissance] IS NULL) OR ([dateNaissance] = @Original_dateNaissance)) AND ([id_tiers_societe] = @Original_id_tiers_societe))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@prenom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="prenom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fonction" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fonction" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mail" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="mail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telFixe" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telFixe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telPortable" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dateNaissance" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_prenom" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="prenom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fonction" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fonction" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_mail" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="mail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telFixe" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telFixe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telPortable" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telPortable" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="telPortable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dateNaissance" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_dateNaissance" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="dateNaissance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id_tiers_societe" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id_tiers_societe" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="nom" DataSetColumn="nom" />
              <Mapping SourceColumn="prenom" DataSetColumn="prenom" />
              <Mapping SourceColumn="fonction" DataSetColumn="fonction" />
              <Mapping SourceColumn="mail" DataSetColumn="mail" />
              <Mapping SourceColumn="telFixe" DataSetColumn="telFixe" />
              <Mapping SourceColumn="telPortable" DataSetColumn="telPortable" />
              <Mapping SourceColumn="dateNaissance" DataSetColumn="dateNaissance" />
              <Mapping SourceColumn="id_tiers_societe" DataSetColumn="id_tiers_societe" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tiers_contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [nom], [prenom], [fonction], [mail], [telFixe], [telPortable], [dateNaissance], [id_tiers_societe] FROM [tiers_contact] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.tiers_contact" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tiers_societeTableAdapter" GeneratorDataComponentClassName="tiers_societeTableAdapter" Name="tiers_societe" UserDataComponentName="tiers_societeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tiers_societe" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[tiers_societe] WHERE (([id] = @Original_id) AND ([raisonSociale] = @Original_raisonSociale) AND ([rue] = @Original_rue) AND ([cp] = @Original_cp) AND ([ville] = @Original_ville) AND ([tel] = @Original_tel) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ([siret] = @Original_siret) AND ((@IsNull_logo = 1 AND [logo] IS NULL) OR ([logo] = @Original_logo)) AND ((@IsNull_remise = 1 AND [remise] IS NULL) OR ([remise] = @Original_remise)) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_raisonSociale" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="raisonSociale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rue" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="rue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_siret" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="siret" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_logo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_logo" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_remise" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_remise" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[tiers_societe] ([id], [raisonSociale], [rue], [cp], [ville], [tel], [fax], [siret], [logo], [remise], [synchro]) VALUES (@id, @raisonSociale, @rue, @cp, @ville, @tel, @fax, @siret, @logo, @remise, @synchro)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@raisonSociale" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="raisonSociale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rue" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="rue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@siret" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="siret" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@logo" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@remise" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [raisonSociale], [rue], [cp], [ville], [tel], [fax], [siret], [logo], [remise], [synchro] FROM [tiers_societe]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[tiers_societe] SET [id] = @id, [raisonSociale] = @raisonSociale, [rue] = @rue, [cp] = @cp, [ville] = @ville, [tel] = @tel, [fax] = @fax, [siret] = @siret, [logo] = @logo, [remise] = @remise, [synchro] = @synchro WHERE (([id] = @Original_id) AND ([raisonSociale] = @Original_raisonSociale) AND ([rue] = @Original_rue) AND ([cp] = @Original_cp) AND ([ville] = @Original_ville) AND ([tel] = @Original_tel) AND ((@IsNull_fax = 1 AND [fax] IS NULL) OR ([fax] = @Original_fax)) AND ([siret] = @Original_siret) AND ((@IsNull_logo = 1 AND [logo] IS NULL) OR ([logo] = @Original_logo)) AND ((@IsNull_remise = 1 AND [remise] IS NULL) OR ([remise] = @Original_remise)) AND ((@IsNull_synchro = 1 AND [synchro] IS NULL) OR ([synchro] = @Original_synchro)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@raisonSociale" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="raisonSociale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rue" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="rue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ville" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fax" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@siret" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="siret" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@logo" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@remise" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_raisonSociale" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="raisonSociale" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rue" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="rue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cp" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="cp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ville" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="ville" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_tel" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="tel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fax" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fax" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_siret" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="siret" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_logo" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_logo" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="logo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_remise" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_remise" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="remise" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_synchro" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_synchro" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="synchro" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="raisonSociale" DataSetColumn="raisonSociale" />
              <Mapping SourceColumn="rue" DataSetColumn="rue" />
              <Mapping SourceColumn="cp" DataSetColumn="cp" />
              <Mapping SourceColumn="ville" DataSetColumn="ville" />
              <Mapping SourceColumn="tel" DataSetColumn="tel" />
              <Mapping SourceColumn="fax" DataSetColumn="fax" />
              <Mapping SourceColumn="siret" DataSetColumn="siret" />
              <Mapping SourceColumn="logo" DataSetColumn="logo" />
              <Mapping SourceColumn="remise" DataSetColumn="remise" />
              <Mapping SourceColumn="synchro" DataSetColumn="synchro" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tiers_societe" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [raisonSociale], [rue], [cp], [ville], [tel], [fax], [siret], [logo], [remise], [synchro] FROM [tiers_societe] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.tiers_societe" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tvaTableAdapter" GeneratorDataComponentClassName="tvaTableAdapter" Name="tva" UserDataComponentName="tvaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tva" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[tva] WHERE (([id] = @Original_id) AND ([Taux] = @Original_Taux))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Taux" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Taux" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[tva] ([id], [Taux]) VALUES (@id, @Taux)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Taux" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Taux" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [Taux] FROM [tva]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[tva] SET [id] = @id, [Taux] = @Taux WHERE (([id] = @Original_id) AND ([Taux] = @Original_Taux))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Taux" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Taux" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Taux" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Taux" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Taux" DataSetColumn="Taux" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.tva" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [Taux] FROM [tva] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.tva" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="uniteTableAdapter" GeneratorDataComponentClassName="uniteTableAdapter" Name="unite" UserDataComponentName="uniteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.unite" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [main].[sqlite_default_schema].[unite] WHERE (([id] = @Original_id) AND ([nom_unite] = @Original_nom_unite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nom_unite" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom_unite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [main].[sqlite_default_schema].[unite] ([id], [nom_unite]) VALUES (@id, @nom_unite)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nom_unite" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom_unite" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [id], [nom_unite] FROM [unite]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [main].[sqlite_default_schema].[unite] SET [id] = @id, [nom_unite] = @nom_unite WHERE (([id] = @Original_id) AND ([nom_unite] = @Original_nom_unite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nom_unite" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom_unite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int64" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nom_unite" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="nom_unite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="nom_unite" DataSetColumn="nom_unite" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="liv3ConnectionString (Settings)" DbObjectName="main.unite" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [id], [nom_unite] FROM [unite] WHERE id = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="main.unite" DataTypeServer="integer(8)" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int64" Scale="0" Size="8" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="liv3DataSetReportViewerCommandePDF" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="liv3DataSetReportViewerCommandePDF" msprop:Generator_UserDSName="liv3DataSetReportViewerCommandePDF">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="agenda" msprop:Generator_TableClassName="agendaDataTable" msprop:Generator_TableVarName="tableagenda" msprop:Generator_RowChangedName="agendaRowChanged" msprop:Generator_TablePropName="agenda" msprop:Generator_RowDeletingName="agendaRowDeleting" msprop:Generator_RowChangingName="agendaRowChanging" msprop:Generator_RowEvHandlerName="agendaRowChangeEventHandler" msprop:Generator_RowDeletedName="agendaRowDeleted" msprop:Generator_RowClassName="agendaRow" msprop:Generator_UserTableName="agenda" msprop:Generator_RowEvArgName="agendaRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="date_debut" msprop:Generator_ColumnVarNameInTable="columndate_debut" msprop:Generator_ColumnPropNameInRow="date_debut" msprop:Generator_ColumnPropNameInTable="date_debutColumn" msprop:Generator_UserColumnName="date_debut" type="xs:decimal" />
              <xs:element name="date_fin" msprop:Generator_ColumnVarNameInTable="columndate_fin" msprop:Generator_ColumnPropNameInRow="date_fin" msprop:Generator_ColumnPropNameInTable="date_finColumn" msprop:Generator_UserColumnName="date_fin" type="xs:decimal" />
              <xs:element name="infos_supp" msprop:Generator_ColumnVarNameInTable="columninfos_supp" msprop:Generator_ColumnPropNameInRow="infos_supp" msprop:Generator_ColumnPropNameInTable="infos_suppColumn" msprop:Generator_UserColumnName="infos_supp" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_tiers_contact" msprop:Generator_ColumnVarNameInTable="columnid_tiers_contact" msprop:Generator_ColumnPropNameInRow="id_tiers_contact" msprop:Generator_ColumnPropNameInTable="id_tiers_contactColumn" msprop:Generator_UserColumnName="id_tiers_contact" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="commandeclient" msprop:Generator_TableClassName="commandeclientDataTable" msprop:Generator_TableVarName="tablecommandeclient" msprop:Generator_RowChangedName="commandeclientRowChanged" msprop:Generator_TablePropName="commandeclient" msprop:Generator_RowDeletingName="commandeclientRowDeleting" msprop:Generator_RowChangingName="commandeclientRowChanging" msprop:Generator_RowEvHandlerName="commandeclientRowChangeEventHandler" msprop:Generator_RowDeletedName="commandeclientRowDeleted" msprop:Generator_RowClassName="commandeclientRow" msprop:Generator_UserTableName="commandeclient" msprop:Generator_RowEvArgName="commandeclientRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="dateCreation" msprop:Generator_ColumnVarNameInTable="columndateCreation" msprop:Generator_ColumnPropNameInRow="dateCreation" msprop:Generator_ColumnPropNameInTable="dateCreationColumn" msprop:Generator_UserColumnName="dateCreation">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="statut" msprop:Generator_ColumnVarNameInTable="columnstatut" msprop:Generator_ColumnPropNameInRow="statut" msprop:Generator_ColumnPropNameInTable="statutColumn" msprop:Generator_UserColumnName="statut" type="xs:long" />
              <xs:element name="totalHT" msprop:Generator_ColumnVarNameInTable="columntotalHT" msprop:Generator_ColumnPropNameInRow="totalHT" msprop:Generator_ColumnPropNameInTable="totalHTColumn" msprop:Generator_UserColumnName="totalHT" type="xs:decimal" minOccurs="0" />
              <xs:element name="totalTTC" msprop:Generator_ColumnVarNameInTable="columntotalTTC" msprop:Generator_ColumnPropNameInRow="totalTTC" msprop:Generator_ColumnPropNameInTable="totalTTCColumn" msprop:Generator_UserColumnName="totalTTC" type="xs:decimal" minOccurs="0" />
              <xs:element name="montantAcompte" msprop:Generator_ColumnVarNameInTable="columnmontantAcompte" msprop:Generator_ColumnPropNameInRow="montantAcompte" msprop:Generator_ColumnPropNameInTable="montantAcompteColumn" msprop:Generator_UserColumnName="montantAcompte" type="xs:decimal" minOccurs="0" />
              <xs:element name="montantTva" msprop:Generator_ColumnVarNameInTable="columnmontantTva" msprop:Generator_ColumnPropNameInRow="montantTva" msprop:Generator_ColumnPropNameInTable="montantTvaColumn" msprop:Generator_UserColumnName="montantTva" type="xs:decimal" minOccurs="0" />
              <xs:element name="montantRemise" msprop:Generator_ColumnVarNameInTable="columnmontantRemise" msprop:Generator_ColumnPropNameInRow="montantRemise" msprop:Generator_ColumnPropNameInTable="montantRemiseColumn" msprop:Generator_UserColumnName="montantRemise" type="xs:decimal" minOccurs="0" />
              <xs:element name="id_tiers_societe" msprop:Generator_ColumnVarNameInTable="columnid_tiers_societe" msprop:Generator_ColumnPropNameInRow="id_tiers_societe" msprop:Generator_ColumnPropNameInTable="id_tiers_societeColumn" msprop:Generator_UserColumnName="id_tiers_societe" type="xs:long" />
              <xs:element name="id_tiers_contact" msprop:Generator_ColumnVarNameInTable="columnid_tiers_contact" msprop:Generator_ColumnPropNameInRow="id_tiers_contact" msprop:Generator_ColumnPropNameInTable="id_tiers_contactColumn" msprop:Generator_UserColumnName="id_tiers_contact" type="xs:long" />
              <xs:element name="synchro" msprop:Generator_ColumnVarNameInTable="columnsynchro" msprop:Generator_ColumnPropNameInRow="synchro" msprop:Generator_ColumnPropNameInTable="synchroColumn" msprop:Generator_UserColumnName="synchro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="france_villes" msprop:Generator_TableClassName="france_villesDataTable" msprop:Generator_TableVarName="tablefrance_villes" msprop:Generator_RowChangedName="france_villesRowChanged" msprop:Generator_TablePropName="france_villes" msprop:Generator_RowDeletingName="france_villesRowDeleting" msprop:Generator_RowChangingName="france_villesRowChanging" msprop:Generator_RowEvHandlerName="france_villesRowChangeEventHandler" msprop:Generator_RowDeletedName="france_villesRowDeleted" msprop:Generator_RowClassName="france_villesRow" msprop:Generator_UserTableName="france_villes" msprop:Generator_RowEvArgName="france_villesRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ville_id" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnville_id" msprop:Generator_ColumnPropNameInRow="ville_id" msprop:Generator_ColumnPropNameInTable="ville_idColumn" msprop:Generator_UserColumnName="ville_id" type="xs:long" />
              <xs:element name="ville_departement" msprop:Generator_ColumnVarNameInTable="columnville_departement" msprop:Generator_ColumnPropNameInRow="ville_departement" msprop:Generator_ColumnPropNameInTable="ville_departementColumn" msprop:Generator_UserColumnName="ville_departement" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_slug" msprop:Generator_ColumnVarNameInTable="columnville_slug" msprop:Generator_ColumnPropNameInRow="ville_slug" msprop:Generator_ColumnPropNameInTable="ville_slugColumn" msprop:Generator_UserColumnName="ville_slug" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_nom" msprop:Generator_ColumnVarNameInTable="columnville_nom" msprop:Generator_ColumnPropNameInRow="ville_nom" msprop:Generator_ColumnPropNameInTable="ville_nomColumn" msprop:Generator_UserColumnName="ville_nom" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_nom_simple" msprop:Generator_ColumnVarNameInTable="columnville_nom_simple" msprop:Generator_ColumnPropNameInRow="ville_nom_simple" msprop:Generator_ColumnPropNameInTable="ville_nom_simpleColumn" msprop:Generator_UserColumnName="ville_nom_simple" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_nom_reel" msprop:Generator_ColumnVarNameInTable="columnville_nom_reel" msprop:Generator_ColumnPropNameInRow="ville_nom_reel" msprop:Generator_ColumnPropNameInTable="ville_nom_reelColumn" msprop:Generator_UserColumnName="ville_nom_reel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_code_postal" msprop:Generator_ColumnVarNameInTable="columnville_code_postal" msprop:Generator_ColumnPropNameInRow="ville_code_postal" msprop:Generator_ColumnPropNameInTable="ville_code_postalColumn" msprop:Generator_UserColumnName="ville_code_postal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_population_2012" msprop:Generator_ColumnVarNameInTable="columnville_population_2012" msprop:Generator_ColumnPropNameInRow="ville_population_2012" msprop:Generator_ColumnPropNameInTable="ville_population_2012Column" msprop:Generator_UserColumnName="ville_population_2012" type="xs:long" minOccurs="0" />
              <xs:element name="ville_longitude_deg" msprop:Generator_ColumnVarNameInTable="columnville_longitude_deg" msprop:Generator_ColumnPropNameInRow="ville_longitude_deg" msprop:Generator_ColumnPropNameInTable="ville_longitude_degColumn" msprop:Generator_UserColumnName="ville_longitude_deg" type="xs:double" minOccurs="0" />
              <xs:element name="ville_latitude_deg" msprop:Generator_ColumnVarNameInTable="columnville_latitude_deg" msprop:Generator_ColumnPropNameInRow="ville_latitude_deg" msprop:Generator_ColumnPropNameInTable="ville_latitude_degColumn" msprop:Generator_UserColumnName="ville_latitude_deg" type="xs:double" minOccurs="0" />
              <xs:element name="ville_nom_departement" msprop:Generator_ColumnVarNameInTable="columnville_nom_departement" msprop:Generator_ColumnPropNameInRow="ville_nom_departement" msprop:Generator_ColumnPropNameInTable="ville_nom_departementColumn" msprop:Generator_UserColumnName="ville_nom_departement" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville_nom_region" msprop:Generator_ColumnVarNameInTable="columnville_nom_region" msprop:Generator_ColumnPropNameInRow="ville_nom_region" msprop:Generator_ColumnPropNameInTable="ville_nom_regionColumn" msprop:Generator_UserColumnName="ville_nom_region" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="lignecommandeclient" msprop:Generator_TableClassName="lignecommandeclientDataTable" msprop:Generator_TableVarName="tablelignecommandeclient" msprop:Generator_RowChangedName="lignecommandeclientRowChanged" msprop:Generator_TablePropName="lignecommandeclient" msprop:Generator_RowDeletingName="lignecommandeclientRowDeleting" msprop:Generator_RowChangingName="lignecommandeclientRowChanging" msprop:Generator_RowEvHandlerName="lignecommandeclientRowChangeEventHandler" msprop:Generator_RowDeletedName="lignecommandeclientRowDeleted" msprop:Generator_RowClassName="lignecommandeclientRow" msprop:Generator_UserTableName="lignecommandeclient" msprop:Generator_RowEvArgName="lignecommandeclientRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="quantite" msprop:Generator_ColumnVarNameInTable="columnquantite" msprop:Generator_ColumnPropNameInRow="quantite" msprop:Generator_ColumnPropNameInTable="quantiteColumn" msprop:Generator_UserColumnName="quantite" type="xs:decimal" />
              <xs:element name="puHT" msprop:Generator_ColumnVarNameInTable="columnpuHT" msprop:Generator_ColumnPropNameInRow="puHT" msprop:Generator_ColumnPropNameInTable="puHTColumn" msprop:Generator_UserColumnName="puHT" type="xs:decimal" />
              <xs:element name="tauxTva" msprop:Generator_ColumnVarNameInTable="columntauxTva" msprop:Generator_ColumnPropNameInRow="tauxTva" msprop:Generator_ColumnPropNameInTable="tauxTvaColumn" msprop:Generator_UserColumnName="tauxTva" type="xs:decimal" />
              <xs:element name="totalHT" msprop:Generator_ColumnVarNameInTable="columntotalHT" msprop:Generator_ColumnPropNameInRow="totalHT" msprop:Generator_ColumnPropNameInTable="totalHTColumn" msprop:Generator_UserColumnName="totalHT" type="xs:decimal" />
              <xs:element name="totalTTC" msprop:Generator_ColumnVarNameInTable="columntotalTTC" msprop:Generator_ColumnPropNameInRow="totalTTC" msprop:Generator_ColumnPropNameInTable="totalTTCColumn" msprop:Generator_UserColumnName="totalTTC" type="xs:decimal" />
              <xs:element name="id_commandeclient" msprop:Generator_ColumnVarNameInTable="columnid_commandeclient" msprop:Generator_ColumnPropNameInRow="id_commandeclient" msprop:Generator_ColumnPropNameInTable="id_commandeclientColumn" msprop:Generator_UserColumnName="id_commandeclient" type="xs:long" />
              <xs:element name="id_produit" msprop:Generator_ColumnVarNameInTable="columnid_produit" msprop:Generator_ColumnPropNameInRow="id_produit" msprop:Generator_ColumnPropNameInTable="id_produitColumn" msprop:Generator_UserColumnName="id_produit" type="xs:long" />
              <xs:element name="synchro" msprop:Generator_ColumnVarNameInTable="columnsynchro" msprop:Generator_ColumnPropNameInRow="synchro" msprop:Generator_ColumnPropNameInTable="synchroColumn" msprop:Generator_UserColumnName="synchro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="produit" msprop:Generator_TableClassName="produitDataTable" msprop:Generator_TableVarName="tableproduit" msprop:Generator_RowChangedName="produitRowChanged" msprop:Generator_TablePropName="produit" msprop:Generator_RowDeletingName="produitRowDeleting" msprop:Generator_RowChangingName="produitRowChanging" msprop:Generator_RowEvHandlerName="produitRowChangeEventHandler" msprop:Generator_RowDeletedName="produitRowDeleted" msprop:Generator_RowClassName="produitRow" msprop:Generator_UserTableName="produit" msprop:Generator_RowEvArgName="produitRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="libelle" msprop:Generator_ColumnVarNameInTable="columnlibelle" msprop:Generator_ColumnPropNameInRow="libelle" msprop:Generator_ColumnPropNameInTable="libelleColumn" msprop:Generator_UserColumnName="libelle">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pu" msprop:Generator_ColumnVarNameInTable="columnpu" msprop:Generator_ColumnPropNameInRow="pu" msprop:Generator_ColumnPropNameInTable="puColumn" msprop:Generator_UserColumnName="pu" type="xs:double" />
              <xs:element name="id_unite" msprop:Generator_ColumnVarNameInTable="columnid_unite" msprop:Generator_ColumnPropNameInRow="id_unite" msprop:Generator_ColumnPropNameInTable="id_uniteColumn" msprop:Generator_UserColumnName="id_unite" type="xs:long" />
              <xs:element name="id_tva" msprop:Generator_ColumnVarNameInTable="columnid_tva" msprop:Generator_ColumnPropNameInRow="id_tva" msprop:Generator_ColumnPropNameInTable="id_tvaColumn" msprop:Generator_UserColumnName="id_tva" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stock" msprop:Generator_TableClassName="stockDataTable" msprop:Generator_TableVarName="tablestock" msprop:Generator_RowChangedName="stockRowChanged" msprop:Generator_TablePropName="stock" msprop:Generator_RowDeletingName="stockRowDeleting" msprop:Generator_RowChangingName="stockRowChanging" msprop:Generator_RowEvHandlerName="stockRowChangeEventHandler" msprop:Generator_RowDeletedName="stockRowDeleted" msprop:Generator_RowClassName="stockRow" msprop:Generator_UserTableName="stock" msprop:Generator_RowEvArgName="stockRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StockDateEntrer" msprop:Generator_ColumnVarNameInTable="columnStockDateEntrer" msprop:Generator_ColumnPropNameInRow="StockDateEntrer" msprop:Generator_ColumnPropNameInTable="StockDateEntrerColumn" msprop:Generator_UserColumnName="StockDateEntrer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StockQuantite" msprop:Generator_ColumnVarNameInTable="columnStockQuantite" msprop:Generator_ColumnPropNameInRow="StockQuantite" msprop:Generator_ColumnPropNameInTable="StockQuantiteColumn" msprop:Generator_UserColumnName="StockQuantite" type="xs:double" />
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tiers_contact" msprop:Generator_TableClassName="tiers_contactDataTable" msprop:Generator_TableVarName="tabletiers_contact" msprop:Generator_RowChangedName="tiers_contactRowChanged" msprop:Generator_TablePropName="tiers_contact" msprop:Generator_RowDeletingName="tiers_contactRowDeleting" msprop:Generator_RowChangingName="tiers_contactRowChanging" msprop:Generator_RowEvHandlerName="tiers_contactRowChangeEventHandler" msprop:Generator_RowDeletedName="tiers_contactRowDeleted" msprop:Generator_RowClassName="tiers_contactRow" msprop:Generator_UserTableName="tiers_contact" msprop:Generator_RowEvArgName="tiers_contactRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="nom" msprop:Generator_ColumnVarNameInTable="columnnom" msprop:Generator_ColumnPropNameInRow="nom" msprop:Generator_ColumnPropNameInTable="nomColumn" msprop:Generator_UserColumnName="nom">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="prenom" msprop:Generator_ColumnVarNameInTable="columnprenom" msprop:Generator_ColumnPropNameInRow="prenom" msprop:Generator_ColumnPropNameInTable="prenomColumn" msprop:Generator_UserColumnName="prenom">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fonction" msprop:Generator_ColumnVarNameInTable="columnfonction" msprop:Generator_ColumnPropNameInRow="fonction" msprop:Generator_ColumnPropNameInTable="fonctionColumn" msprop:Generator_UserColumnName="fonction">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mail" msprop:Generator_ColumnVarNameInTable="columnmail" msprop:Generator_ColumnPropNameInRow="mail" msprop:Generator_ColumnPropNameInTable="mailColumn" msprop:Generator_UserColumnName="mail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telFixe" msprop:Generator_ColumnVarNameInTable="columntelFixe" msprop:Generator_ColumnPropNameInRow="telFixe" msprop:Generator_ColumnPropNameInTable="telFixeColumn" msprop:Generator_UserColumnName="telFixe">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telPortable" msprop:Generator_ColumnVarNameInTable="columntelPortable" msprop:Generator_ColumnPropNameInRow="telPortable" msprop:Generator_ColumnPropNameInTable="telPortableColumn" msprop:Generator_UserColumnName="telPortable" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateNaissance" msprop:Generator_ColumnVarNameInTable="columndateNaissance" msprop:Generator_ColumnPropNameInRow="dateNaissance" msprop:Generator_ColumnPropNameInTable="dateNaissanceColumn" msprop:Generator_UserColumnName="dateNaissance" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="id_tiers_societe" msprop:Generator_ColumnVarNameInTable="columnid_tiers_societe" msprop:Generator_ColumnPropNameInRow="id_tiers_societe" msprop:Generator_ColumnPropNameInTable="id_tiers_societeColumn" msprop:Generator_UserColumnName="id_tiers_societe" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tiers_societe" msprop:Generator_TableClassName="tiers_societeDataTable" msprop:Generator_TableVarName="tabletiers_societe" msprop:Generator_RowChangedName="tiers_societeRowChanged" msprop:Generator_TablePropName="tiers_societe" msprop:Generator_RowDeletingName="tiers_societeRowDeleting" msprop:Generator_RowChangingName="tiers_societeRowChanging" msprop:Generator_RowEvHandlerName="tiers_societeRowChangeEventHandler" msprop:Generator_RowDeletedName="tiers_societeRowDeleted" msprop:Generator_RowClassName="tiers_societeRow" msprop:Generator_UserTableName="tiers_societe" msprop:Generator_RowEvArgName="tiers_societeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="raisonSociale" msprop:Generator_ColumnVarNameInTable="columnraisonSociale" msprop:Generator_ColumnPropNameInRow="raisonSociale" msprop:Generator_ColumnPropNameInTable="raisonSocialeColumn" msprop:Generator_UserColumnName="raisonSociale">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rue" msprop:Generator_ColumnVarNameInTable="columnrue" msprop:Generator_ColumnPropNameInRow="rue" msprop:Generator_ColumnPropNameInTable="rueColumn" msprop:Generator_UserColumnName="rue">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cp" msprop:Generator_ColumnVarNameInTable="columncp" msprop:Generator_ColumnPropNameInRow="cp" msprop:Generator_ColumnPropNameInTable="cpColumn" msprop:Generator_UserColumnName="cp">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ville" msprop:Generator_ColumnVarNameInTable="columnville" msprop:Generator_ColumnPropNameInRow="ville" msprop:Generator_ColumnPropNameInTable="villeColumn" msprop:Generator_UserColumnName="ville">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tel" msprop:Generator_ColumnVarNameInTable="columntel" msprop:Generator_ColumnPropNameInRow="tel" msprop:Generator_ColumnPropNameInTable="telColumn" msprop:Generator_UserColumnName="tel">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fax" msprop:Generator_ColumnVarNameInTable="columnfax" msprop:Generator_ColumnPropNameInRow="fax" msprop:Generator_ColumnPropNameInTable="faxColumn" msprop:Generator_UserColumnName="fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="siret" msprop:Generator_ColumnVarNameInTable="columnsiret" msprop:Generator_ColumnPropNameInRow="siret" msprop:Generator_ColumnPropNameInTable="siretColumn" msprop:Generator_UserColumnName="siret">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="logo" msprop:Generator_ColumnVarNameInTable="columnlogo" msprop:Generator_ColumnPropNameInRow="logo" msprop:Generator_ColumnPropNameInTable="logoColumn" msprop:Generator_UserColumnName="logo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="remise" msprop:Generator_ColumnVarNameInTable="columnremise" msprop:Generator_ColumnPropNameInRow="remise" msprop:Generator_ColumnPropNameInTable="remiseColumn" msprop:Generator_UserColumnName="remise" type="xs:long" minOccurs="0" />
              <xs:element name="synchro" msprop:Generator_ColumnVarNameInTable="columnsynchro" msprop:Generator_ColumnPropNameInRow="synchro" msprop:Generator_ColumnPropNameInTable="synchroColumn" msprop:Generator_UserColumnName="synchro" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tva" msprop:Generator_TableClassName="tvaDataTable" msprop:Generator_TableVarName="tabletva" msprop:Generator_RowChangedName="tvaRowChanged" msprop:Generator_TablePropName="tva" msprop:Generator_RowDeletingName="tvaRowDeleting" msprop:Generator_RowChangingName="tvaRowChanging" msprop:Generator_RowEvHandlerName="tvaRowChangeEventHandler" msprop:Generator_RowDeletedName="tvaRowDeleted" msprop:Generator_RowClassName="tvaRow" msprop:Generator_UserTableName="tva" msprop:Generator_RowEvArgName="tvaRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="Taux" msprop:Generator_ColumnVarNameInTable="columnTaux" msprop:Generator_ColumnPropNameInRow="Taux" msprop:Generator_ColumnPropNameInTable="TauxColumn" msprop:Generator_UserColumnName="Taux" type="xs:double" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="unite" msprop:Generator_TableClassName="uniteDataTable" msprop:Generator_TableVarName="tableunite" msprop:Generator_RowChangedName="uniteRowChanged" msprop:Generator_TablePropName="unite" msprop:Generator_RowDeletingName="uniteRowDeleting" msprop:Generator_RowChangingName="uniteRowChanging" msprop:Generator_RowEvHandlerName="uniteRowChangeEventHandler" msprop:Generator_RowDeletedName="uniteRowDeleted" msprop:Generator_RowClassName="uniteRow" msprop:Generator_UserTableName="unite" msprop:Generator_RowEvArgName="uniteRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:long" />
              <xs:element name="nom_unite" msprop:Generator_ColumnVarNameInTable="columnnom_unite" msprop:Generator_ColumnPropNameInRow="nom_unite" msprop:Generator_ColumnPropNameInTable="nom_uniteColumn" msprop:Generator_UserColumnName="nom_unite">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:agenda" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="commandeclient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:commandeclient" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="france_villes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:france_villes" />
      <xs:field xpath="mstns:ville_id" />
    </xs:unique>
    <xs:unique name="lignecommandeclient_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:lignecommandeclient" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="produit_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:produit" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="stock_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:stock" />
      <xs:field xpath="mstns:StockDateEntrer" />
    </xs:unique>
    <xs:unique name="tiers_contact_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tiers_contact" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tiers_societe_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tiers_societe" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tva_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tva" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="unite_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:unite" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_agenda_0_0" msdata:parent="tiers_contact" msdata:child="agenda" msdata:parentkey="id" msdata:childkey="id_tiers_contact" msprop:Generator_UserChildTable="agenda" msprop:Generator_ChildPropName="GetagendaRows" msprop:Generator_UserRelationName="FK_agenda_0_0" msprop:Generator_ParentPropName="tiers_contactRow" msprop:Generator_RelationVarName="relationFK_agenda_0_0" msprop:Generator_UserParentTable="tiers_contact" />
      <msdata:Relationship name="FK_commandeclient_0_0" msdata:parent="tiers_contact" msdata:child="commandeclient" msdata:parentkey="id" msdata:childkey="id_tiers_contact" msprop:Generator_UserChildTable="commandeclient" msprop:Generator_ChildPropName="GetcommandeclientRows" msprop:Generator_UserRelationName="FK_commandeclient_0_0" msprop:Generator_ParentPropName="tiers_contactRow" msprop:Generator_RelationVarName="relationFK_commandeclient_0_0" msprop:Generator_UserParentTable="tiers_contact" />
      <msdata:Relationship name="FK_commandeclient_1_0" msdata:parent="tiers_societe" msdata:child="commandeclient" msdata:parentkey="id" msdata:childkey="id_tiers_societe" msprop:Generator_UserChildTable="commandeclient" msprop:Generator_ChildPropName="GetcommandeclientRows" msprop:Generator_UserRelationName="FK_commandeclient_1_0" msprop:Generator_ParentPropName="tiers_societeRow" msprop:Generator_RelationVarName="relationFK_commandeclient_1_0" msprop:Generator_UserParentTable="tiers_societe" />
      <msdata:Relationship name="FK_lignecommandeclient_0_0" msdata:parent="produit" msdata:child="lignecommandeclient" msdata:parentkey="id" msdata:childkey="id_produit" msprop:Generator_UserChildTable="lignecommandeclient" msprop:Generator_ChildPropName="GetlignecommandeclientRows" msprop:Generator_UserRelationName="FK_lignecommandeclient_0_0" msprop:Generator_ParentPropName="produitRow" msprop:Generator_RelationVarName="relationFK_lignecommandeclient_0_0" msprop:Generator_UserParentTable="produit" />
      <msdata:Relationship name="FK_lignecommandeclient_1_0" msdata:parent="commandeclient" msdata:child="lignecommandeclient" msdata:parentkey="id" msdata:childkey="id_commandeclient" msprop:Generator_UserChildTable="lignecommandeclient" msprop:Generator_ChildPropName="GetlignecommandeclientRows" msprop:Generator_UserRelationName="FK_lignecommandeclient_1_0" msprop:Generator_RelationVarName="relationFK_lignecommandeclient_1_0" msprop:Generator_UserParentTable="commandeclient" msprop:Generator_ParentPropName="commandeclientRow" />
      <msdata:Relationship name="FK_produit_0_0" msdata:parent="tva" msdata:child="produit" msdata:parentkey="id" msdata:childkey="id_tva" msprop:Generator_UserChildTable="produit" msprop:Generator_ChildPropName="GetproduitRows" msprop:Generator_UserRelationName="FK_produit_0_0" msprop:Generator_ParentPropName="tvaRow" msprop:Generator_RelationVarName="relationFK_produit_0_0" msprop:Generator_UserParentTable="tva" />
      <msdata:Relationship name="FK_produit_1_0" msdata:parent="unite" msdata:child="produit" msdata:parentkey="id" msdata:childkey="id_unite" msprop:Generator_UserChildTable="produit" msprop:Generator_ChildPropName="GetproduitRows" msprop:Generator_UserRelationName="FK_produit_1_0" msprop:Generator_ParentPropName="uniteRow" msprop:Generator_RelationVarName="relationFK_produit_1_0" msprop:Generator_UserParentTable="unite" />
      <msdata:Relationship name="FK_stock_0_0" msdata:parent="produit" msdata:child="stock" msdata:parentkey="id" msdata:childkey="id" msprop:Generator_UserChildTable="stock" msprop:Generator_ChildPropName="GetstockRows" msprop:Generator_UserRelationName="FK_stock_0_0" msprop:Generator_RelationVarName="relationFK_stock_0_0" msprop:Generator_UserParentTable="produit" msprop:Generator_ParentPropName="produitRow" />
      <msdata:Relationship name="FK_tiers_contact_0_0" msdata:parent="tiers_societe" msdata:child="tiers_contact" msdata:parentkey="id" msdata:childkey="id_tiers_societe" msprop:Generator_UserChildTable="tiers_contact" msprop:Generator_ChildPropName="Gettiers_contactRows" msprop:Generator_UserRelationName="FK_tiers_contact_0_0" msprop:Generator_ParentPropName="tiers_societeRow" msprop:Generator_RelationVarName="relationFK_tiers_contact_0_0" msprop:Generator_UserParentTable="tiers_societe" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>